from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, ForeignKey, UniqueConstraint, Index
from sqlalchemy.orm import sessionmaker, relationship
from sqlalchemy import create_engine


Base = declarative_base()


class Goods(Base):
    __tablename__ = 'goods'
    id = Column(Integer, primary_key=True, autoincrement=True)    #主键，自增
    trade_item_id = Column(String(32))
    title = Column(String(128))
    category = Column(String(128))
    link = Column(String(1024))
    org_price = Column(String(32))
    price = Column(String(32))
    sale = Column(String(32))


